CREATE TABLE tb_Player(
	PlayerId INT NOT NULL IDENTITY(1, 1),
	Forename VARCHAR(50) NOT NULL,
	Surname VARCHAR(50) NOT NULL,
	Gender CHAR(1) NOT NULL,
	Hometown VARCHAR(50) NOT NULL,
	CountyId INT NOT NULL,
	CONSTRAINT PK_Player PRIMARY KEY (PlayerId),
	CONSTRAINT FK_Player_County FOREIGN KEY (CountyId)
		REFERENCES tb_County (CountyId),
	CONSTRAINT CK_Player_Gender CHECK (Gender IN ('M', 'F')))